Overview
Brought to you by YData
Dataset statistics
| Number of variables | 21 |
|---|---|
| Number of observations | 150000 |
| Missing cells | 1123500 |
| Missing cells (%) | 35.7% |
| Duplicate rows | 0 |
| Duplicate rows (%) | 0.0% |
| Total size in memory | 100.7 MiB |
| Average record size in memory | 704.0 B |
Variable types
| DateTime | 2 |
|---|---|
| Text | 4 |
| Categorical | 9 |
| Numeric | 6 |
Cancelled Rides by Customer has constant value "1.0" | Constant |
Cancelled Rides by Driver has constant value "1.0" | Constant |
Incomplete Rides has constant value "1.0" | Constant |
Booking Status is highly overall correlated with Customer Rating and 4 other fields | High correlation |
Customer Rating is highly overall correlated with Booking Status | High correlation |
Driver Cancellation Reason is highly overall correlated with Booking Status | High correlation |
Driver Ratings is highly overall correlated with Booking Status | High correlation |
Incomplete Rides Reason is highly overall correlated with Booking Status | High correlation |
Reason for cancelling by Customer is highly overall correlated with Booking Status | High correlation |
Avg VTAT has 10500 (7.0%) missing values | Missing |
Avg CTAT has 48000 (32.0%) missing values | Missing |
Cancelled Rides by Customer has 139500 (93.0%) missing values | Missing |
Reason for cancelling by Customer has 139500 (93.0%) missing values | Missing |
Cancelled Rides by Driver has 123000 (82.0%) missing values | Missing |
Driver Cancellation Reason has 123000 (82.0%) missing values | Missing |
Incomplete Rides has 141000 (94.0%) missing values | Missing |
Incomplete Rides Reason has 141000 (94.0%) missing values | Missing |
Booking Value has 48000 (32.0%) missing values | Missing |
Ride Distance has 48000 (32.0%) missing values | Missing |
Driver Ratings has 57000 (38.0%) missing values | Missing |
Customer Rating has 57000 (38.0%) missing values | Missing |
Payment Method has 48000 (32.0%) missing values | Missing |
Reproduction
| Analysis started | 2025-08-30 11:27:45.661032 |
|---|---|
| Analysis finished | 2025-08-30 11:28:04.408630 |
| Duration | 18.75 seconds |
| Software version | ydata-profiling vv4.16.1 |
| Download configuration | config.json |
Variables
Date
Date
| Distinct | 365 |
|---|---|
| Distinct (%) | 0.2% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 1.1 MiB |
| Minimum | 2024-01-01 00:00:00 |
|---|---|
| Maximum | 2024-12-30 00:00:00 |
| Invalid dates | 0 |
| Invalid dates (%) | 0.0% |
Time
Date
| Distinct | 62910 |
|---|---|
| Distinct (%) | 41.9% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 1.1 MiB |
| Minimum | 2025-08-30 00:00:00 |
|---|---|
| Maximum | 2025-08-30 23:59:59 |
| Invalid dates | 0 |
| Invalid dates (%) | 0.0% |
Booking ID
Text
| Distinct | 148767 |
|---|---|
| Distinct (%) | 99.2% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 8.7 MiB |
Length
| Max length | 12 |
|---|---|
| Median length | 12 |
| Mean length | 12 |
| Min length | 12 |
Unique
| Unique | 147543 ? |
|---|---|
| Unique (%) | 98.4% |
Sample
| 1st row | "CNR5884300" |
|---|---|
| 2nd row | "CNR1326809" |
| 3rd row | "CNR8494506" |
| 4th row | "CNR8906825" |
| 5th row | "CNR1950162" |
| Value | Count | Frequency (%) |
| cnr6337479 | 3 | < 0.1% |
| cnr3648267 | 3 | < 0.1% |
| cnr9603232 | 3 | < 0.1% |
| cnr5292943 | 3 | < 0.1% |
| cnr7585544 | 3 | < 0.1% |
| cnr7199036 | 3 | < 0.1% |
| cnr7642097 | 3 | < 0.1% |
| cnr2726142 | 3 | < 0.1% |
| cnr7908610 | 3 | < 0.1% |
| cnr2869280 | 2 | < 0.1% |
| Other values (148757) | 149971 |
Most occurring characters
| Value | Count | Frequency (%) |
| " | 300000 | |
| C | 150000 | 8.3% |
| N | 150000 | 8.3% |
| R | 150000 | 8.3% |
| 9 | 107075 | 5.9% |
| 5 | 106822 | 5.9% |
| 4 | 106770 | 5.9% |
| 7 | 106760 | 5.9% |
| 6 | 106752 | 5.9% |
| 8 | 106627 | 5.9% |
| Other values (4) | 409194 |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 1800000 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| " | 300000 | |
| C | 150000 | 8.3% |
| N | 150000 | 8.3% |
| R | 150000 | 8.3% |
| 9 | 107075 | 5.9% |
| 5 | 106822 | 5.9% |
| 4 | 106770 | 5.9% |
| 7 | 106760 | 5.9% |
| 6 | 106752 | 5.9% |
| 8 | 106627 | 5.9% |
| Other values (4) | 409194 |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 1800000 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| " | 300000 | |
| C | 150000 | 8.3% |
| N | 150000 | 8.3% |
| R | 150000 | 8.3% |
| 9 | 107075 | 5.9% |
| 5 | 106822 | 5.9% |
| 4 | 106770 | 5.9% |
| 7 | 106760 | 5.9% |
| 6 | 106752 | 5.9% |
| 8 | 106627 | 5.9% |
| Other values (4) | 409194 |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 1800000 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| " | 300000 | |
| C | 150000 | 8.3% |
| N | 150000 | 8.3% |
| R | 150000 | 8.3% |
| 9 | 107075 | 5.9% |
| 5 | 106822 | 5.9% |
| 4 | 106770 | 5.9% |
| 7 | 106760 | 5.9% |
| 6 | 106752 | 5.9% |
| 8 | 106627 | 5.9% |
| Other values (4) | 409194 |
Booking Status
Categorical
High correlation 
| Distinct | 5 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 8.7 MiB |
| Completed | |
|---|---|
| Cancelled by Driver | |
| No Driver Found | |
| Cancelled by Customer | |
| Incomplete | 9000 |
Length
| Max length | 21 |
|---|---|
| Median length | 9 |
| Mean length | 12.12 |
| Min length | 9 |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | No Driver Found |
|---|---|
| 2nd row | Incomplete |
| 3rd row | Completed |
| 4th row | Completed |
| 5th row | Completed |
Common Values
| Value | Count | Frequency (%) |
| Completed | 93000 | |
| Cancelled by Driver | 27000 | 18.0% |
| No Driver Found | 10500 | 7.0% |
| Cancelled by Customer | 10500 | 7.0% |
| Incomplete | 9000 | 6.0% |
Length
Common Values (Plot)
| Value | Count | Frequency (%) |
| completed | 93000 | |
| cancelled | 37500 | |
| by | 37500 | |
| driver | 37500 | |
| no | 10500 | 4.3% |
| found | 10500 | 4.3% |
| customer | 10500 | 4.3% |
| incomplete | 9000 | 3.7% |
Most occurring characters
| Value | Count | Frequency (%) |
| e | 327000 | |
| l | 177000 | |
| C | 141000 | 7.8% |
| d | 141000 | 7.8% |
| o | 133500 | 7.3% |
| t | 112500 | 6.2% |
| m | 112500 | 6.2% |
| p | 102000 | 5.6% |
| 96000 | 5.3% | |
| r | 85500 | 4.7% |
| Other values (13) | 390000 |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 1818000 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| e | 327000 | |
| l | 177000 | |
| C | 141000 | 7.8% |
| d | 141000 | 7.8% |
| o | 133500 | 7.3% |
| t | 112500 | 6.2% |
| m | 112500 | 6.2% |
| p | 102000 | 5.6% |
| 96000 | 5.3% | |
| r | 85500 | 4.7% |
| Other values (13) | 390000 |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 1818000 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| e | 327000 | |
| l | 177000 | |
| C | 141000 | 7.8% |
| d | 141000 | 7.8% |
| o | 133500 | 7.3% |
| t | 112500 | 6.2% |
| m | 112500 | 6.2% |
| p | 102000 | 5.6% |
| 96000 | 5.3% | |
| r | 85500 | 4.7% |
| Other values (13) | 390000 |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 1818000 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| e | 327000 | |
| l | 177000 | |
| C | 141000 | 7.8% |
| d | 141000 | 7.8% |
| o | 133500 | 7.3% |
| t | 112500 | 6.2% |
| m | 112500 | 6.2% |
| p | 102000 | 5.6% |
| 96000 | 5.3% | |
| r | 85500 | 4.7% |
| Other values (13) | 390000 |
Customer ID
Text
| Distinct | 148788 |
|---|---|
| Distinct (%) | 99.2% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 8.7 MiB |
Length
| Max length | 12 |
|---|---|
| Median length | 12 |
| Mean length | 12 |
| Min length | 12 |
Unique
| Unique | 147582 ? |
|---|---|
| Unique (%) | 98.4% |
Sample
| 1st row | "CID1982111" |
|---|---|
| 2nd row | "CID4604802" |
| 3rd row | "CID9202816" |
| 4th row | "CID2610914" |
| 5th row | "CID9933542" |
| Value | Count | Frequency (%) |
| cid8727691 | 3 | < 0.1% |
| cid4523979 | 3 | < 0.1% |
| cid6715450 | 3 | < 0.1% |
| cid7828101 | 3 | < 0.1% |
| cid6468528 | 3 | < 0.1% |
| cid5481002 | 3 | < 0.1% |
| cid4977850 | 2 | < 0.1% |
| cid7088244 | 2 | < 0.1% |
| cid7294800 | 2 | < 0.1% |
| cid2877369 | 2 | < 0.1% |
| Other values (148778) | 149974 |
Most occurring characters
| Value | Count | Frequency (%) |
| " | 300000 | |
| C | 150000 | 8.3% |
| I | 150000 | 8.3% |
| D | 150000 | 8.3% |
| 4 | 107135 | 6.0% |
| 1 | 107018 | 5.9% |
| 6 | 107016 | 5.9% |
| 9 | 106654 | 5.9% |
| 7 | 106632 | 5.9% |
| 5 | 106484 | 5.9% |
| Other values (4) | 409061 |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 1800000 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| " | 300000 | |
| C | 150000 | 8.3% |
| I | 150000 | 8.3% |
| D | 150000 | 8.3% |
| 4 | 107135 | 6.0% |
| 1 | 107018 | 5.9% |
| 6 | 107016 | 5.9% |
| 9 | 106654 | 5.9% |
| 7 | 106632 | 5.9% |
| 5 | 106484 | 5.9% |
| Other values (4) | 409061 |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 1800000 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| " | 300000 | |
| C | 150000 | 8.3% |
| I | 150000 | 8.3% |
| D | 150000 | 8.3% |
| 4 | 107135 | 6.0% |
| 1 | 107018 | 5.9% |
| 6 | 107016 | 5.9% |
| 9 | 106654 | 5.9% |
| 7 | 106632 | 5.9% |
| 5 | 106484 | 5.9% |
| Other values (4) | 409061 |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 1800000 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| " | 300000 | |
| C | 150000 | 8.3% |
| I | 150000 | 8.3% |
| D | 150000 | 8.3% |
| 4 | 107135 | 6.0% |
| 1 | 107018 | 5.9% |
| 6 | 107016 | 5.9% |
| 9 | 106654 | 5.9% |
| 7 | 106632 | 5.9% |
| 5 | 106484 | 5.9% |
| Other values (4) | 409061 |
Vehicle Type
Categorical
| Distinct | 7 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 7.9 MiB |
| Auto | |
|---|---|
| Go Mini | |
| Go Sedan | |
| Bike | |
| Premier Sedan | |
| Other values (2) |
Length
| Max length | 13 |
|---|---|
| Median length | 8 |
| Mean length | 6.5659 |
| Min length | 4 |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | eBike |
|---|---|
| 2nd row | Go Sedan |
| 3rd row | Auto |
| 4th row | Premier Sedan |
| 5th row | Bike |
Common Values
| Value | Count | Frequency (%) |
| Auto | 37419 | |
| Go Mini | 29806 | |
| Go Sedan | 27141 | |
| Bike | 22517 | |
| Premier Sedan | 18111 | |
| eBike | 10557 | 7.0% |
| Uber XL | 4449 | 3.0% |
Length
Common Values (Plot)
| Value | Count | Frequency (%) |
| go | 56947 | |
| sedan | 45252 | |
| auto | 37419 | |
| mini | 29806 | |
| bike | 22517 | 9.8% |
| premier | 18111 | 7.9% |
| ebike | 10557 | 4.6% |
| uber | 4449 | 1.9% |
| xl | 4449 | 1.9% |
Most occurring characters
| Value | Count | Frequency (%) |
| e | 129554 | |
| i | 110797 | |
| o | 94366 | 9.6% |
| 79507 | 8.1% | |
| n | 75058 | 7.6% |
| G | 56947 | 5.8% |
| a | 45252 | 4.6% |
| d | 45252 | 4.6% |
| S | 45252 | 4.6% |
| r | 40671 | 4.1% |
| Other values (12) | 262229 |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 984885 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| e | 129554 | |
| i | 110797 | |
| o | 94366 | 9.6% |
| 79507 | 8.1% | |
| n | 75058 | 7.6% |
| G | 56947 | 5.8% |
| a | 45252 | 4.6% |
| d | 45252 | 4.6% |
| S | 45252 | 4.6% |
| r | 40671 | 4.1% |
| Other values (12) | 262229 |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 984885 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| e | 129554 | |
| i | 110797 | |
| o | 94366 | 9.6% |
| 79507 | 8.1% | |
| n | 75058 | 7.6% |
| G | 56947 | 5.8% |
| a | 45252 | 4.6% |
| d | 45252 | 4.6% |
| S | 45252 | 4.6% |
| r | 40671 | 4.1% |
| Other values (12) | 262229 |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 984885 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| e | 129554 | |
| i | 110797 | |
| o | 94366 | 9.6% |
| 79507 | 8.1% | |
| n | 75058 | 7.6% |
| G | 56947 | 5.8% |
| a | 45252 | 4.6% |
| d | 45252 | 4.6% |
| S | 45252 | 4.6% |
| r | 40671 | 4.1% |
| Other values (12) | 262229 |
Pickup Location
Text
| Distinct | 176 |
|---|---|
| Distinct (%) | 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 8.7 MiB |
Length
| Max length | 25 |
|---|---|
| Median length | 19 |
| Mean length | 11.505627 |
| Min length | 3 |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | Palam Vihar |
|---|---|
| 2nd row | Shastri Nagar |
| 3rd row | Khandsa |
| 4th row | Central Secretariat |
| 5th row | Ghitorni Village |
| Value | Count | Frequency (%) |
| nagar | 14525 | 5.2% |
| vihar | 8410 | 3.0% |
| chowk | 6860 | 2.5% |
| park | 5246 | 1.9% |
| sector | 5031 | 1.8% |
| gurgaon | 5016 | 1.8% |
| road | 4244 | 1.5% |
| noida | 4209 | 1.5% |
| city | 3460 | 1.2% |
| garden | 3408 | 1.2% |
| Other values (214) | 217828 |
Most occurring characters
| Value | Count | Frequency (%) |
| a | 277598 | |
| r | 128582 | 7.5% |
| 128237 | 7.4% | |
| i | 109699 | 6.4% |
| h | 89268 | 5.2% |
| n | 74783 | 4.3% |
| e | 72093 | 4.2% |
| o | 68791 | 4.0% |
| t | 56145 | 3.3% |
| u | 53591 | 3.1% |
| Other values (48) | 667057 |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 1725844 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| a | 277598 | |
| r | 128582 | 7.5% |
| 128237 | 7.4% | |
| i | 109699 | 6.4% |
| h | 89268 | 5.2% |
| n | 74783 | 4.3% |
| e | 72093 | 4.2% |
| o | 68791 | 4.0% |
| t | 56145 | 3.3% |
| u | 53591 | 3.1% |
| Other values (48) | 667057 |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 1725844 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| a | 277598 | |
| r | 128582 | 7.5% |
| 128237 | 7.4% | |
| i | 109699 | 6.4% |
| h | 89268 | 5.2% |
| n | 74783 | 4.3% |
| e | 72093 | 4.2% |
| o | 68791 | 4.0% |
| t | 56145 | 3.3% |
| u | 53591 | 3.1% |
| Other values (48) | 667057 |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 1725844 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| a | 277598 | |
| r | 128582 | 7.5% |
| 128237 | 7.4% | |
| i | 109699 | 6.4% |
| h | 89268 | 5.2% |
| n | 74783 | 4.3% |
| e | 72093 | 4.2% |
| o | 68791 | 4.0% |
| t | 56145 | 3.3% |
| u | 53591 | 3.1% |
| Other values (48) | 667057 |
Drop Location
Text
| Distinct | 176 |
|---|---|
| Distinct (%) | 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 8.7 MiB |
Length
| Max length | 25 |
|---|---|
| Median length | 20 |
| Mean length | 11.511813 |
| Min length | 3 |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | Jhilmil |
|---|---|
| 2nd row | Gurgaon Sector 56 |
| 3rd row | Malviya Nagar |
| 4th row | Inderlok |
| 5th row | Khan Market |
| Value | Count | Frequency (%) |
| nagar | 14533 | 5.2% |
| vihar | 8538 | 3.1% |
| chowk | 6656 | 2.4% |
| sector | 5148 | 1.8% |
| gurgaon | 5084 | 1.8% |
| park | 5002 | 1.8% |
| noida | 4315 | 1.5% |
| road | 4130 | 1.5% |
| gate | 3481 | 1.2% |
| place | 3458 | 1.2% |
| Other values (214) | 218245 |
Most occurring characters
| Value | Count | Frequency (%) |
| a | 277071 | |
| r | 128702 | 7.5% |
| 128590 | 7.4% | |
| i | 109858 | 6.4% |
| h | 89698 | 5.2% |
| n | 74820 | 4.3% |
| e | 72505 | 4.2% |
| o | 69018 | 4.0% |
| t | 56302 | 3.3% |
| u | 53474 | 3.1% |
| Other values (48) | 666734 |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 1726772 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| a | 277071 | |
| r | 128702 | 7.5% |
| 128590 | 7.4% | |
| i | 109858 | 6.4% |
| h | 89698 | 5.2% |
| n | 74820 | 4.3% |
| e | 72505 | 4.2% |
| o | 69018 | 4.0% |
| t | 56302 | 3.3% |
| u | 53474 | 3.1% |
| Other values (48) | 666734 |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 1726772 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| a | 277071 | |
| r | 128702 | 7.5% |
| 128590 | 7.4% | |
| i | 109858 | 6.4% |
| h | 89698 | 5.2% |
| n | 74820 | 4.3% |
| e | 72505 | 4.2% |
| o | 69018 | 4.0% |
| t | 56302 | 3.3% |
| u | 53474 | 3.1% |
| Other values (48) | 666734 |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 1726772 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| a | 277071 | |
| r | 128702 | 7.5% |
| 128590 | 7.4% | |
| i | 109858 | 6.4% |
| h | 89698 | 5.2% |
| n | 74820 | 4.3% |
| e | 72505 | 4.2% |
| o | 69018 | 4.0% |
| t | 56302 | 3.3% |
| u | 53474 | 3.1% |
| Other values (48) | 666734 |
Avg VTAT
Real number (ℝ)
Missing 
| Distinct | 181 |
|---|---|
| Distinct (%) | 0.1% |
| Missing | 10500 |
| Missing (%) | 7.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 8.456352 |
| Minimum | 2 |
|---|---|
| Maximum | 20 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 1.1 MiB |
Quantile statistics
| Minimum | 2 |
|---|---|
| 5-th percentile | 2.9 |
| Q1 | 5.3 |
| median | 8.3 |
| Q3 | 11.3 |
| 95-th percentile | 14.6 |
| Maximum | 20 |
| Range | 18 |
| Interquartile range (IQR) | 6 |
Descriptive statistics
| Standard deviation | 3.7735638 |
|---|---|
| Coefficient of variation (CV) | 0.44624016 |
| Kurtosis | -0.59788646 |
| Mean | 8.456352 |
| Median Absolute Deviation (MAD) | 3 |
| Skewness | 0.30656478 |
| Sum | 1179661.1 |
| Variance | 14.239784 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 9.4 | 1259 | 0.8% |
| 6 | 1249 | 0.8% |
| 5.8 | 1248 | 0.8% |
| 9.5 | 1246 | 0.8% |
| 6.5 | 1239 | 0.8% |
| 6.2 | 1237 | 0.8% |
| 5.1 | 1235 | 0.8% |
| 7.7 | 1230 | 0.8% |
| 6.7 | 1228 | 0.8% |
| 8.9 | 1224 | 0.8% |
| Other values (171) | 127105 | |
| (Missing) | 10500 | 7.0% |
| Value | Count | Frequency (%) |
| 2 | 411 | |
| 2.1 | 838 | |
| 2.2 | 787 | |
| 2.3 | 791 | |
| 2.4 | 810 | |
| 2.5 | 819 | |
| 2.6 | 812 | |
| 2.7 | 787 | |
| 2.8 | 814 | |
| 2.9 | 824 |
| Value | Count | Frequency (%) |
| 20 | 38 | |
| 19.9 | 84 | |
| 19.8 | 78 | |
| 19.7 | 68 | |
| 19.6 | 78 | |
| 19.5 | 57 | |
| 19.4 | 92 | |
| 19.3 | 61 | |
| 19.2 | 75 | |
| 19.1 | 59 |
Avg CTAT
Real number (ℝ)
Missing 
| Distinct | 351 |
|---|---|
| Distinct (%) | 0.3% |
| Missing | 48000 |
| Missing (%) | 32.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 29.149636 |
| Minimum | 10 |
|---|---|
| Maximum | 45 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 1.1 MiB |
Quantile statistics
| Minimum | 10 |
|---|---|
| 5-th percentile | 15.8 |
| Q1 | 21.6 |
| median | 28.8 |
| Q3 | 36.8 |
| 95-th percentile | 43.4 |
| Maximum | 45 |
| Range | 35 |
| Interquartile range (IQR) | 15.2 |
Descriptive statistics
| Standard deviation | 8.9025772 |
|---|---|
| Coefficient of variation (CV) | 0.30540955 |
| Kurtosis | -1.1235657 |
| Mean | 29.149636 |
| Median Absolute Deviation (MAD) | 7.6 |
| Skewness | 0.045899577 |
| Sum | 2973262.9 |
| Variance | 79.255882 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 24.8 | 401 | 0.3% |
| 25.9 | 389 | 0.3% |
| 28.1 | 388 | 0.3% |
| 20.5 | 386 | 0.3% |
| 25.3 | 383 | 0.3% |
| 17.2 | 382 | 0.3% |
| 23.5 | 381 | 0.3% |
| 18.5 | 380 | 0.3% |
| 27.7 | 380 | 0.3% |
| 20 | 380 | 0.3% |
| Other values (341) | 98150 | |
| (Missing) | 48000 |
| Value | Count | Frequency (%) |
| 10 | 23 | |
| 10.1 | 48 | |
| 10.2 | 44 | |
| 10.3 | 43 | |
| 10.4 | 52 | |
| 10.5 | 48 | |
| 10.6 | 47 | |
| 10.7 | 48 | |
| 10.8 | 43 | |
| 10.9 | 43 |
| Value | Count | Frequency (%) |
| 45 | 144 | |
| 44.9 | 318 | |
| 44.8 | 315 | |
| 44.7 | 333 | |
| 44.6 | 306 | |
| 44.5 | 296 | |
| 44.4 | 320 | |
| 44.3 | 259 | |
| 44.2 | 304 | |
| 44.1 | 317 |
Cancelled Rides by Customer
Categorical
Constant  Missing 
| Distinct | 1 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 139500 |
| Missing (%) | 93.0% |
| Memory size | 8.0 MiB |
| 1.0 |
|---|
Length
| Max length | 3 |
|---|---|
| Median length | 3 |
| Mean length | 3 |
| Min length | 3 |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | 1.0 |
|---|---|
| 2nd row | 1.0 |
| 3rd row | 1.0 |
| 4th row | 1.0 |
| 5th row | 1.0 |
Common Values
| Value | Count | Frequency (%) |
| 1.0 | 10500 | 7.0% |
| (Missing) | 139500 |
Length
Common Values (Plot)
| Value | Count | Frequency (%) |
| 1.0 | 10500 |
Most occurring characters
| Value | Count | Frequency (%) |
| 1 | 10500 | |
| . | 10500 | |
| 0 | 10500 |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 31500 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| 1 | 10500 | |
| . | 10500 | |
| 0 | 10500 |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 31500 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| 1 | 10500 | |
| . | 10500 | |
| 0 | 10500 |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 31500 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| 1 | 10500 | |
| . | 10500 | |
| 0 | 10500 |
Reason for cancelling by Customer
Categorical
High correlation  Missing 
| Distinct | 5 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 139500 |
| Missing (%) | 93.0% |
| Memory size | 8.2 MiB |
| Wrong Address | |
|---|---|
| Change of plans | |
| Driver is not moving towards pickup location | |
| Driver asked to cancel | |
| AC is not working |
Length
| Max length | 44 |
|---|---|
| Median length | 17 |
| Mean length | 22.749143 |
| Min length | 13 |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | Driver is not moving towards pickup location |
|---|---|
| 2nd row | Driver is not moving towards pickup location |
| 3rd row | Driver asked to cancel |
| 4th row | Driver is not moving towards pickup location |
| 5th row | Driver asked to cancel |
Common Values
| Value | Count | Frequency (%) |
| Wrong Address | 2362 | 1.6% |
| Change of plans | 2353 | 1.6% |
| Driver is not moving towards pickup location | 2335 | 1.6% |
| Driver asked to cancel | 2295 | 1.5% |
| AC is not working | 1155 | 0.8% |
| (Missing) | 139500 |
Length
Common Values (Plot)
| Value | Count | Frequency (%) |
| driver | 4630 | 11.0% |
| not | 3490 | 8.3% |
| is | 3490 | 8.3% |
| wrong | 2362 | 5.6% |
| address | 2362 | 5.6% |
| plans | 2353 | 5.6% |
| of | 2353 | 5.6% |
| change | 2353 | 5.6% |
| moving | 2335 | 5.6% |
| towards | 2335 | 5.6% |
| Other values (7) | 13865 |
Most occurring characters
| Value | Count | Frequency (%) |
| 31428 | ||
| o | 20995 | 8.8% |
| n | 18678 | 7.8% |
| r | 17474 | 7.3% |
| i | 16280 | 6.8% |
| s | 15197 | 6.4% |
| a | 13966 | 5.8% |
| e | 13935 | 5.8% |
| t | 10455 | 4.4% |
| d | 9354 | 3.9% |
| Other values (15) | 71104 |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 238866 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| 31428 | ||
| o | 20995 | 8.8% |
| n | 18678 | 7.8% |
| r | 17474 | 7.3% |
| i | 16280 | 6.8% |
| s | 15197 | 6.4% |
| a | 13966 | 5.8% |
| e | 13935 | 5.8% |
| t | 10455 | 4.4% |
| d | 9354 | 3.9% |
| Other values (15) | 71104 |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 238866 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| 31428 | ||
| o | 20995 | 8.8% |
| n | 18678 | 7.8% |
| r | 17474 | 7.3% |
| i | 16280 | 6.8% |
| s | 15197 | 6.4% |
| a | 13966 | 5.8% |
| e | 13935 | 5.8% |
| t | 10455 | 4.4% |
| d | 9354 | 3.9% |
| Other values (15) | 71104 |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 238866 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| 31428 | ||
| o | 20995 | 8.8% |
| n | 18678 | 7.8% |
| r | 17474 | 7.3% |
| i | 16280 | 6.8% |
| s | 15197 | 6.4% |
| a | 13966 | 5.8% |
| e | 13935 | 5.8% |
| t | 10455 | 4.4% |
| d | 9354 | 3.9% |
| Other values (15) | 71104 |
Cancelled Rides by Driver
Categorical
Constant  Missing 
| Distinct | 1 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 123000 |
| Missing (%) | 82.0% |
| Memory size | 7.9 MiB |
| 1.0 |
|---|
Length
| Max length | 3 |
|---|---|
| Median length | 3 |
| Mean length | 3 |
| Min length | 3 |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | 1.0 |
|---|---|
| 2nd row | 1.0 |
| 3rd row | 1.0 |
| 4th row | 1.0 |
| 5th row | 1.0 |
Common Values
| Value | Count | Frequency (%) |
| 1.0 | 27000 | 18.0% |
| (Missing) | 123000 |
Length
Common Values (Plot)
| Value | Count | Frequency (%) |
| 1.0 | 27000 |
Most occurring characters
| Value | Count | Frequency (%) |
| 1 | 27000 | |
| . | 27000 | |
| 0 | 27000 |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 81000 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| 1 | 27000 | |
| . | 27000 | |
| 0 | 27000 |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 81000 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| 1 | 27000 | |
| . | 27000 | |
| 0 | 27000 |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 81000 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| 1 | 27000 | |
| . | 27000 | |
| 0 | 27000 |
Driver Cancellation Reason
Categorical
High correlation  Missing 
| Distinct | 4 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 123000 |
| Missing (%) | 82.0% |
| Memory size | 8.6 MiB |
| Customer related issue | |
|---|---|
| The customer was coughing/sick | |
| Personal & Car related issues | |
| More than permitted people in there |
Length
| Max length | 35 |
|---|---|
| Median length | 30 |
| Mean length | 28.963259 |
| Min length | 22 |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | Personal & Car related issues |
|---|---|
| 2nd row | Customer related issue |
| 3rd row | Customer related issue |
| 4th row | Personal & Car related issues |
| 5th row | More than permitted people in there |
Common Values
| Value | Count | Frequency (%) |
| Customer related issue | 6837 | 4.6% |
| The customer was coughing/sick | 6751 | 4.5% |
| Personal & Car related issues | 6726 | 4.5% |
| More than permitted people in there | 6686 | 4.5% |
| (Missing) | 123000 |
Length
Common Values (Plot)
| Value | Count | Frequency (%) |
| customer | 13588 | 11.2% |
| related | 13563 | 11.2% |
| issue | 6837 | 5.6% |
| the | 6751 | 5.6% |
| was | 6751 | 5.6% |
| coughing/sick | 6751 | 5.6% |
| personal | 6726 | 5.5% |
| 6726 | 5.5% | |
| car | 6726 | 5.5% |
| issues | 6726 | 5.5% |
| Other values (6) | 40116 |
Most occurring characters
| Value | Count | Frequency (%) |
| e | 114556 | |
| 94261 | ||
| s | 67668 | 8.7% |
| r | 60661 | 7.8% |
| t | 53895 | 6.9% |
| a | 40452 | 5.2% |
| o | 40437 | 5.2% |
| i | 40437 | 5.2% |
| u | 33902 | 4.3% |
| l | 26975 | 3.4% |
| Other values (15) | 208764 |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 782008 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| e | 114556 | |
| 94261 | ||
| s | 67668 | 8.7% |
| r | 60661 | 7.8% |
| t | 53895 | 6.9% |
| a | 40452 | 5.2% |
| o | 40437 | 5.2% |
| i | 40437 | 5.2% |
| u | 33902 | 4.3% |
| l | 26975 | 3.4% |
| Other values (15) | 208764 |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 782008 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| e | 114556 | |
| 94261 | ||
| s | 67668 | 8.7% |
| r | 60661 | 7.8% |
| t | 53895 | 6.9% |
| a | 40452 | 5.2% |
| o | 40437 | 5.2% |
| i | 40437 | 5.2% |
| u | 33902 | 4.3% |
| l | 26975 | 3.4% |
| Other values (15) | 208764 |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 782008 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| e | 114556 | |
| 94261 | ||
| s | 67668 | 8.7% |
| r | 60661 | 7.8% |
| t | 53895 | 6.9% |
| a | 40452 | 5.2% |
| o | 40437 | 5.2% |
| i | 40437 | 5.2% |
| u | 33902 | 4.3% |
| l | 26975 | 3.4% |
| Other values (15) | 208764 |
Incomplete Rides
Categorical
Constant  Missing 
| Distinct | 1 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 141000 |
| Missing (%) | 94.0% |
| Memory size | 8.0 MiB |
| 1.0 |
|---|
Length
| Max length | 3 |
|---|---|
| Median length | 3 |
| Mean length | 3 |
| Min length | 3 |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | 1.0 |
|---|---|
| 2nd row | 1.0 |
| 3rd row | 1.0 |
| 4th row | 1.0 |
| 5th row | 1.0 |
Common Values
| Value | Count | Frequency (%) |
| 1.0 | 9000 | 6.0% |
| (Missing) | 141000 |
Length
Common Values (Plot)
| Value | Count | Frequency (%) |
| 1.0 | 9000 |
Most occurring characters
| Value | Count | Frequency (%) |
| 1 | 9000 | |
| . | 9000 | |
| 0 | 9000 |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 27000 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| 1 | 9000 | |
| . | 9000 | |
| 0 | 9000 |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 27000 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| 1 | 9000 | |
| . | 9000 | |
| 0 | 9000 |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 27000 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| 1 | 9000 | |
| . | 9000 | |
| 0 | 9000 |
Incomplete Rides Reason
Categorical
High correlation  Missing 
| Distinct | 3 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 141000 |
| Missing (%) | 94.0% |
| Memory size | 8.1 MiB |
| Customer Demand | |
|---|---|
| Vehicle Breakdown | |
| Other Issue |
Length
| Max length | 17 |
|---|---|
| Median length | 15 |
| Mean length | 14.359111 |
| Min length | 11 |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | Vehicle Breakdown |
|---|---|
| 2nd row | Other Issue |
| 3rd row | Vehicle Breakdown |
| 4th row | Other Issue |
| 5th row | Vehicle Breakdown |
Common Values
| Value | Count | Frequency (%) |
| Customer Demand | 3040 | 2.0% |
| Vehicle Breakdown | 3012 | 2.0% |
| Other Issue | 2948 | 2.0% |
| (Missing) | 141000 |
Length
Common Values (Plot)
| Value | Count | Frequency (%) |
| customer | 3040 | |
| demand | 3040 | |
| vehicle | 3012 | |
| breakdown | 3012 | |
| other | 2948 | |
| issue | 2948 |
Most occurring characters
| Value | Count | Frequency (%) |
| e | 21012 | |
| 9000 | 7.0% | |
| r | 9000 | 7.0% |
| s | 8936 | 6.9% |
| m | 6080 | 4.7% |
| o | 6052 | 4.7% |
| a | 6052 | 4.7% |
| d | 6052 | 4.7% |
| n | 6052 | 4.7% |
| u | 5988 | 4.6% |
| Other values (13) | 45008 |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 129232 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| e | 21012 | |
| 9000 | 7.0% | |
| r | 9000 | 7.0% |
| s | 8936 | 6.9% |
| m | 6080 | 4.7% |
| o | 6052 | 4.7% |
| a | 6052 | 4.7% |
| d | 6052 | 4.7% |
| n | 6052 | 4.7% |
| u | 5988 | 4.6% |
| Other values (13) | 45008 |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 129232 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| e | 21012 | |
| 9000 | 7.0% | |
| r | 9000 | 7.0% |
| s | 8936 | 6.9% |
| m | 6080 | 4.7% |
| o | 6052 | 4.7% |
| a | 6052 | 4.7% |
| d | 6052 | 4.7% |
| n | 6052 | 4.7% |
| u | 5988 | 4.6% |
| Other values (13) | 45008 |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 129232 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| e | 21012 | |
| 9000 | 7.0% | |
| r | 9000 | 7.0% |
| s | 8936 | 6.9% |
| m | 6080 | 4.7% |
| o | 6052 | 4.7% |
| a | 6052 | 4.7% |
| d | 6052 | 4.7% |
| n | 6052 | 4.7% |
| u | 5988 | 4.6% |
| Other values (13) | 45008 |
Booking Value
Real number (ℝ)
Missing 
| Distinct | 2566 |
|---|---|
| Distinct (%) | 2.5% |
| Missing | 48000 |
| Missing (%) | 32.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 508.29591 |
| Minimum | 50 |
|---|---|
| Maximum | 4277 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 1.1 MiB |
Quantile statistics
| Minimum | 50 |
|---|---|
| 5-th percentile | 91 |
| Q1 | 234 |
| median | 414 |
| Q3 | 689 |
| 95-th percentile | 1224 |
| Maximum | 4277 |
| Range | 4227 |
| Interquartile range (IQR) | 455 |
Descriptive statistics
| Standard deviation | 395.80577 |
|---|---|
| Coefficient of variation (CV) | 0.77869163 |
| Kurtosis | 9.8878804 |
| Mean | 508.29591 |
| Median Absolute Deviation (MAD) | 211 |
| Skewness | 2.287351 |
| Sum | 51846183 |
| Variance | 156662.21 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 176 | 177 | 0.1% |
| 125 | 174 | 0.1% |
| 200 | 170 | 0.1% |
| 408 | 169 | 0.1% |
| 186 | 168 | 0.1% |
| 353 | 167 | 0.1% |
| 357 | 166 | 0.1% |
| 157 | 166 | 0.1% |
| 470 | 166 | 0.1% |
| 206 | 165 | 0.1% |
| Other values (2556) | 100312 | |
| (Missing) | 48000 |
| Value | Count | Frequency (%) |
| 50 | 121 | |
| 51 | 108 | |
| 52 | 116 | |
| 53 | 137 | |
| 54 | 96 | |
| 55 | 105 | |
| 56 | 115 | |
| 57 | 113 | |
| 58 | 109 | |
| 59 | 116 |
| Value | Count | Frequency (%) |
| 4277 | 1 | |
| 4228 | 1 | |
| 4220 | 1 | |
| 4202 | 1 | |
| 4133 | 1 | |
| 4109 | 1 | |
| 4093 | 1 | |
| 4088 | 1 | |
| 4060 | 1 | |
| 4044 | 1 |
Ride Distance
Real number (ℝ)
Missing 
| Distinct | 4901 |
|---|---|
| Distinct (%) | 4.8% |
| Missing | 48000 |
| Missing (%) | 32.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 24.637012 |
| Minimum | 1 |
|---|---|
| Maximum | 50 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 1.1 MiB |
Quantile statistics
| Minimum | 1 |
|---|---|
| 5-th percentile | 3.97 |
| Q1 | 12.46 |
| median | 23.72 |
| Q3 | 36.82 |
| 95-th percentile | 47.35 |
| Maximum | 50 |
| Range | 49 |
| Interquartile range (IQR) | 24.36 |
Descriptive statistics
| Standard deviation | 14.002138 |
|---|---|
| Coefficient of variation (CV) | 0.56833753 |
| Kurtosis | -1.2122664 |
| Mean | 24.637012 |
| Median Absolute Deviation (MAD) | 12.1 |
| Skewness | 0.12831234 |
| Sum | 2512975.2 |
| Variance | 196.05988 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 17.31 | 43 | < 0.1% |
| 9.61 | 43 | < 0.1% |
| 14.47 | 42 | < 0.1% |
| 3.44 | 41 | < 0.1% |
| 12.87 | 41 | < 0.1% |
| 12.52 | 40 | < 0.1% |
| 12.67 | 39 | < 0.1% |
| 8.69 | 39 | < 0.1% |
| 8.97 | 39 | < 0.1% |
| 14.93 | 38 | < 0.1% |
| Other values (4891) | 101595 | |
| (Missing) | 48000 |
| Value | Count | Frequency (%) |
| 1 | 6 | |
| 1.01 | 3 | |
| 1.02 | 3 | |
| 1.03 | 5 | |
| 1.04 | 3 | |
| 1.05 | 3 | |
| 1.06 | 4 | |
| 1.07 | 6 | |
| 1.08 | 1 | < 0.1% |
| 1.09 | 5 |
| Value | Count | Frequency (%) |
| 50 | 9 | < 0.1% |
| 49.99 | 19 | |
| 49.98 | 20 | |
| 49.97 | 22 | |
| 49.96 | 18 | |
| 49.95 | 17 | |
| 49.94 | 21 | |
| 49.93 | 24 | |
| 49.92 | 16 | |
| 49.91 | 18 |
Driver Ratings
Real number (ℝ)
High correlation  Missing 
| Distinct | 21 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 57000 |
| Missing (%) | 38.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 4.2309925 |
| Minimum | 3 |
|---|---|
| Maximum | 5 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 1.1 MiB |
Quantile statistics
| Minimum | 3 |
|---|---|
| 5-th percentile | 3.3 |
| Q1 | 4.1 |
| median | 4.3 |
| Q3 | 4.6 |
| 95-th percentile | 4.9 |
| Maximum | 5 |
| Range | 2 |
| Interquartile range (IQR) | 0.5 |
Descriptive statistics
| Standard deviation | 0.43687147 |
|---|---|
| Coefficient of variation (CV) | 0.10325508 |
| Kurtosis | 0.2802387 |
| Mean | 4.2309925 |
| Median Absolute Deviation (MAD) | 0.2 |
| Skewness | -0.65571516 |
| Sum | 393482.3 |
| Variance | 0.19085668 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 4.3 | 14081 | 9.4% |
| 4.2 | 13841 | 9.2% |
| 4.6 | 9368 | 6.2% |
| 4.4 | 7018 | 4.7% |
| 4.1 | 6966 | 4.6% |
| 4.9 | 4705 | 3.1% |
| 4.7 | 4678 | 3.1% |
| 4.5 | 4634 | 3.1% |
| 3.9 | 3915 | 2.6% |
| 3.8 | 3848 | 2.6% |
| Other values (11) | 19946 | 13.3% |
| (Missing) | 57000 |
| Value | Count | Frequency (%) |
| 3 | 745 | 0.5% |
| 3.1 | 1459 | 1.0% |
| 3.2 | 1538 | 1.0% |
| 3.3 | 1461 | 1.0% |
| 3.4 | 1491 | 1.0% |
| 3.5 | 748 | 0.5% |
| 3.6 | 2026 | |
| 3.7 | 3790 | |
| 3.8 | 3848 | |
| 3.9 | 3915 |
| Value | Count | Frequency (%) |
| 5 | 2365 | 1.6% |
| 4.9 | 4705 | 3.1% |
| 4.8 | 2328 | 1.6% |
| 4.7 | 4678 | 3.1% |
| 4.6 | 9368 | |
| 4.5 | 4634 | 3.1% |
| 4.4 | 7018 | |
| 4.3 | 14081 | |
| 4.2 | 13841 | |
| 4.1 | 6966 |
Customer Rating
Real number (ℝ)
High correlation  Missing 
| Distinct | 21 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 57000 |
| Missing (%) | 38.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 4.4045839 |
| Minimum | 3 |
|---|---|
| Maximum | 5 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 1.1 MiB |
Quantile statistics
| Minimum | 3 |
|---|---|
| 5-th percentile | 3.6 |
| Q1 | 4.2 |
| median | 4.5 |
| Q3 | 4.8 |
| 95-th percentile | 5 |
| Maximum | 5 |
| Range | 2 |
| Interquartile range (IQR) | 0.6 |
Descriptive statistics
| Standard deviation | 0.43781873 |
|---|---|
| Coefficient of variation (CV) | 0.099400703 |
| Kurtosis | 0.64796636 |
| Mean | 4.4045839 |
| Median Absolute Deviation (MAD) | 0.3 |
| Skewness | -0.88553068 |
| Sum | 409626.3 |
| Variance | 0.19168524 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 4.9 | 11642 | 7.8% |
| 4.6 | 11533 | 7.7% |
| 4.3 | 10995 | 7.3% |
| 4.2 | 10697 | 7.1% |
| 4.5 | 5890 | 3.9% |
| 4.8 | 5880 | 3.9% |
| 5 | 5837 | 3.9% |
| 4.7 | 5763 | 3.8% |
| 4.1 | 5396 | 3.6% |
| 4.4 | 5279 | 3.5% |
| Other values (11) | 14088 | 9.4% |
| (Missing) | 57000 |
| Value | Count | Frequency (%) |
| 3 | 468 | 0.3% |
| 3.1 | 1008 | |
| 3.2 | 881 | 0.6% |
| 3.3 | 900 | 0.6% |
| 3.4 | 928 | 0.6% |
| 3.5 | 443 | 0.3% |
| 3.6 | 1194 | |
| 3.7 | 2354 | |
| 3.8 | 2357 | |
| 3.9 | 2370 |
| Value | Count | Frequency (%) |
| 5 | 5837 | |
| 4.9 | 11642 | |
| 4.8 | 5880 | |
| 4.7 | 5763 | |
| 4.6 | 11533 | |
| 4.5 | 5890 | |
| 4.4 | 5279 | |
| 4.3 | 10995 | |
| 4.2 | 10697 | |
| 4.1 | 5396 |
Payment Method
Categorical
Missing 
| Distinct | 5 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 48000 |
| Missing (%) | 32.0% |
| Memory size | 7.9 MiB |
| UPI | |
|---|---|
| Cash | |
| Uber Wallet | |
| Credit Card | |
| Debit Card |
Length
| Max length | 11 |
|---|---|
| Median length | 10 |
| Mean length | 5.5776471 |
| Min length | 3 |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | UPI |
|---|---|
| 2nd row | Debit Card |
| 3rd row | UPI |
| 4th row | UPI |
| 5th row | UPI |
Common Values
| Value | Count | Frequency (%) |
| UPI | 45909 | |
| Cash | 25367 | |
| Uber Wallet | 12276 | 8.2% |
| Credit Card | 10209 | 6.8% |
| Debit Card | 8239 | 5.5% |
| (Missing) | 48000 |
Length
Common Values (Plot)
| Value | Count | Frequency (%) |
| upi | 45909 | |
| cash | 25367 | |
| card | 18448 | |
| uber | 12276 | 9.2% |
| wallet | 12276 | 9.2% |
| credit | 10209 | 7.7% |
| debit | 8239 | 6.2% |
Most occurring characters
| Value | Count | Frequency (%) |
| U | 58185 | |
| a | 56091 | |
| C | 54024 | |
| I | 45909 | 8.1% |
| P | 45909 | 8.1% |
| e | 43000 | 7.6% |
| r | 40933 | 7.2% |
| 30724 | 5.4% | |
| t | 30724 | 5.4% |
| d | 28657 | 5.0% |
| Other values (7) | 134764 |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 568920 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| U | 58185 | |
| a | 56091 | |
| C | 54024 | |
| I | 45909 | 8.1% |
| P | 45909 | 8.1% |
| e | 43000 | 7.6% |
| r | 40933 | 7.2% |
| 30724 | 5.4% | |
| t | 30724 | 5.4% |
| d | 28657 | 5.0% |
| Other values (7) | 134764 |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 568920 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| U | 58185 | |
| a | 56091 | |
| C | 54024 | |
| I | 45909 | 8.1% |
| P | 45909 | 8.1% |
| e | 43000 | 7.6% |
| r | 40933 | 7.2% |
| 30724 | 5.4% | |
| t | 30724 | 5.4% |
| d | 28657 | 5.0% |
| Other values (7) | 134764 |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 568920 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| U | 58185 | |
| a | 56091 | |
| C | 54024 | |
| I | 45909 | 8.1% |
| P | 45909 | 8.1% |
| e | 43000 | 7.6% |
| r | 40933 | 7.2% |
| 30724 | 5.4% | |
| t | 30724 | 5.4% |
| d | 28657 | 5.0% |
| Other values (7) | 134764 |
Interactions
Correlations
| Avg CTAT | Avg VTAT | Booking Status | Booking Value | Customer Rating | Driver Cancellation Reason | Driver Ratings | Incomplete Rides Reason | Payment Method | Reason for cancelling by Customer | Ride Distance | Vehicle Type | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|
| Avg CTAT | 1.000 | 0.059 | 0.471 | 0.001 | 0.000 | 0.000 | 0.000 | 0.000 | 0.000 | 0.000 | 0.099 | 0.000 |
| Avg VTAT | 0.059 | 1.000 | 0.338 | 0.005 | -0.003 | 0.000 | -0.005 | 0.000 | 0.000 | 0.012 | 0.063 | 0.000 |
| Booking Status | 0.471 | 0.338 | 1.000 | 0.002 | 1.000 | 1.000 | 1.000 | 1.000 | 0.000 | 1.000 | 0.353 | 0.002 |
| Booking Value | 0.001 | 0.005 | 0.002 | 1.000 | -0.004 | 0.000 | 0.001 | 0.000 | 0.000 | 0.000 | 0.004 | 0.000 |
| Customer Rating | 0.000 | -0.003 | 1.000 | -0.004 | 1.000 | 0.000 | -0.002 | 0.000 | 0.000 | 0.000 | 0.005 | 0.005 |
| Driver Cancellation Reason | 0.000 | 0.000 | 1.000 | 0.000 | 0.000 | 1.000 | 0.000 | 0.000 | 0.000 | 0.000 | 0.000 | 0.000 |
| Driver Ratings | 0.000 | -0.005 | 1.000 | 0.001 | -0.002 | 0.000 | 1.000 | 0.000 | 0.000 | 0.000 | -0.001 | 0.000 |
| Incomplete Rides Reason | 0.000 | 0.000 | 1.000 | 0.000 | 0.000 | 0.000 | 0.000 | 1.000 | 0.000 | 0.000 | 0.013 | 0.016 |
| Payment Method | 0.000 | 0.000 | 0.000 | 0.000 | 0.000 | 0.000 | 0.000 | 0.000 | 1.000 | 0.000 | 0.005 | 0.006 |
| Reason for cancelling by Customer | 0.000 | 0.012 | 1.000 | 0.000 | 0.000 | 0.000 | 0.000 | 0.000 | 0.000 | 1.000 | 0.000 | 0.168 |
| Ride Distance | 0.099 | 0.063 | 0.353 | 0.004 | 0.005 | 0.000 | -0.001 | 0.013 | 0.005 | 0.000 | 1.000 | 0.000 |
| Vehicle Type | 0.000 | 0.000 | 0.002 | 0.000 | 0.005 | 0.000 | 0.000 | 0.016 | 0.006 | 0.168 | 0.000 | 1.000 |
Missing values
Sample
| Date | Time | Booking ID | Booking Status | Customer ID | Vehicle Type | Pickup Location | Drop Location | Avg VTAT | Avg CTAT | Cancelled Rides by Customer | Reason for cancelling by Customer | Cancelled Rides by Driver | Driver Cancellation Reason | Incomplete Rides | Incomplete Rides Reason | Booking Value | Ride Distance | Driver Ratings | Customer Rating | Payment Method | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 0 | 2024-03-23 | 12:29:38 | "CNR5884300" | No Driver Found | "CID1982111" | eBike | Palam Vihar | Jhilmil | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN |
| 1 | 2024-11-29 | 18:01:39 | "CNR1326809" | Incomplete | "CID4604802" | Go Sedan | Shastri Nagar | Gurgaon Sector 56 | 4.9 | 14.0 | NaN | NaN | NaN | NaN | 1.0 | Vehicle Breakdown | 237.0 | 5.73 | NaN | NaN | UPI |
| 2 | 2024-08-23 | 08:56:10 | "CNR8494506" | Completed | "CID9202816" | Auto | Khandsa | Malviya Nagar | 13.4 | 25.8 | NaN | NaN | NaN | NaN | NaN | NaN | 627.0 | 13.58 | 4.9 | 4.9 | Debit Card |
| 3 | 2024-10-21 | 17:17:25 | "CNR8906825" | Completed | "CID2610914" | Premier Sedan | Central Secretariat | Inderlok | 13.1 | 28.5 | NaN | NaN | NaN | NaN | NaN | NaN | 416.0 | 34.02 | 4.6 | 5.0 | UPI |
| 4 | 2024-09-16 | 22:08:00 | "CNR1950162" | Completed | "CID9933542" | Bike | Ghitorni Village | Khan Market | 5.3 | 19.6 | NaN | NaN | NaN | NaN | NaN | NaN | 737.0 | 48.21 | 4.1 | 4.3 | UPI |
| 5 | 2024-02-06 | 09:44:56 | "CNR4096693" | Completed | "CID4670564" | Auto | AIIMS | Narsinghpur | 5.1 | 18.1 | NaN | NaN | NaN | NaN | NaN | NaN | 316.0 | 4.85 | 4.1 | 4.6 | UPI |
| 6 | 2024-06-17 | 15:45:58 | "CNR2002539" | Completed | "CID6800553" | Go Mini | Vaishali | Punjabi Bagh | 7.1 | 20.4 | NaN | NaN | NaN | NaN | NaN | NaN | 640.0 | 41.24 | 4.0 | 4.1 | UPI |
| 7 | 2024-03-19 | 17:37:37 | "CNR6568000" | Completed | "CID8610436" | Auto | Mayur Vihar | Cyber Hub | 12.1 | 16.5 | NaN | NaN | NaN | NaN | NaN | NaN | 136.0 | 6.56 | 4.4 | 4.2 | UPI |
| 8 | 2024-09-14 | 12:49:09 | "CNR4510807" | No Driver Found | "CID7873618" | Go Sedan | Noida Sector 62 | Noida Sector 18 | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN |
| 9 | 2024-12-16 | 19:06:48 | "CNR7721892" | Incomplete | "CID5214275" | Auto | Rohini | Adarsh Nagar | 6.1 | 26.0 | NaN | NaN | NaN | NaN | 1.0 | Other Issue | 135.0 | 10.36 | NaN | NaN | Cash |
| Date | Time | Booking ID | Booking Status | Customer ID | Vehicle Type | Pickup Location | Drop Location | Avg VTAT | Avg CTAT | Cancelled Rides by Customer | Reason for cancelling by Customer | Cancelled Rides by Driver | Driver Cancellation Reason | Incomplete Rides | Incomplete Rides Reason | Booking Value | Ride Distance | Driver Ratings | Customer Rating | Payment Method | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 149990 | 2024-09-26 | 12:31:22 | "CNR3212810" | Cancelled by Driver | "CID6199171" | Auto | Kashmere Gate ISBT | GTB Nagar | 10.7 | NaN | NaN | NaN | 1.0 | Personal & Car related issues | NaN | NaN | NaN | NaN | NaN | NaN | NaN |
| 149991 | 2024-07-13 | 14:47:30 | "CNR5591053" | Completed | "CID1829616" | Auto | Karol Bagh | Vishwavidyalaya | 11.2 | 30.8 | NaN | NaN | NaN | NaN | NaN | NaN | 597.0 | 27.91 | 4.2 | 4.3 | UPI |
| 149992 | 2024-01-24 | 18:02:28 | "CNR1717894" | No Driver Found | "CID9564749" | Go Mini | Nehru Place | Aya Nagar | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN |
| 149993 | 2024-05-03 | 11:18:17 | "CNR9715958" | Completed | "CID8835432" | Go Mini | Tughlakabad | Jama Masjid | 13.2 | 20.1 | NaN | NaN | NaN | NaN | NaN | NaN | 280.0 | 29.89 | 4.1 | 4.7 | Cash |
| 149994 | 2024-06-14 | 16:46:53 | "CNR9572383" | Completed | "CID2952237" | Go Mini | Akshardham | Greater Noida | 8.2 | 30.6 | NaN | NaN | NaN | NaN | NaN | NaN | 388.0 | 10.51 | 4.3 | 4.9 | UPI |
| 149995 | 2024-11-11 | 19:34:01 | "CNR6500631" | Completed | "CID4337371" | Go Mini | MG Road | Ghitorni | 10.2 | 44.4 | NaN | NaN | NaN | NaN | NaN | NaN | 475.0 | 40.08 | 3.7 | 4.1 | Uber Wallet |
| 149996 | 2024-11-24 | 15:55:09 | "CNR2468611" | Completed | "CID2325623" | Go Mini | Golf Course Road | Akshardham | 5.1 | 30.8 | NaN | NaN | NaN | NaN | NaN | NaN | 1093.0 | 21.31 | 4.8 | 5.0 | UPI |
| 149997 | 2024-09-18 | 10:55:15 | "CNR6358306" | Completed | "CID9925486" | Go Sedan | Satguru Ram Singh Marg | Jor Bagh | 2.7 | 23.4 | NaN | NaN | NaN | NaN | NaN | NaN | 852.0 | 15.93 | 3.9 | 4.4 | Cash |
| 149998 | 2024-10-05 | 07:53:34 | "CNR3030099" | Completed | "CID9415487" | Auto | Ghaziabad | Saidulajab | 6.9 | 39.6 | NaN | NaN | NaN | NaN | NaN | NaN | 333.0 | 45.54 | 4.1 | 3.7 | UPI |
| 149999 | 2024-03-10 | 15:38:03 | "CNR3447390" | Completed | "CID4108667" | Premier Sedan | Ashok Park Main | Gurgaon Sector 29 | 3.5 | 33.7 | NaN | NaN | NaN | NaN | NaN | NaN | 806.0 | 21.19 | 4.6 | 4.9 | Credit Card |